{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "8608bbf3",
   "metadata": {},
   "source": [
    "### 地图API_Web服务API简介\n",
    "* 高德Web服务API向开发者提供HTTP接口，开发者可通过这些接口使用各类型的地理数据服务，返回结果支持JSON和XML格式。Web服务API对所有用户开放。使用本组服务之前，需要申请应用Key。不同类型用户可获取不同的数据访问能力。\n",
    "#### 地理/逆地理编码\n",
    "* 结构化地址：\n",
    "> 首先，地址肯定是一串字符，内含国家、省份、城市、区县、城镇、乡村、街道、门牌号码、屋邨、大厦等建筑物名称。按照由大区域名称到小区域名称组合在一起的字符。一个有效的地址应该是独一无二的。注意：针对大陆、港、澳地区的地理编码转换时可以将国家信息选择性的忽略，但省、市、城镇等级别的地址构成是不能忽略的。暂时不支持返回台湾省的详细地址信息。\n",
    "* 结构化地址<--->经纬度\n",
    "> 地理编码/逆地理编码 API 是通过 HTTP/HTTPS 协议访问远程服务的接口，提供结构化地址与经纬度之间的相互转化的能力。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "caa388d2",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 1.调用requests模块（google chrome浏览器）\n",
    "import requests\n",
    "\n",
    "# 2.请求方法：GET\n",
    "\n",
    "# 3.URL地址：https://restapi.amap.com/v3/geocode/geo?parameters\n",
    "geo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "\n",
    "# 4.准备参数，用于交换数据 payload\n",
    "payload ={\n",
    "    \"key\":\"b0121f143057c2f0c3607e48fe21bac9\",\n",
    "    \"address\":\"广东省广州市从化区广州南方学院\"\n",
    "}\n",
    "\n",
    "# 5.发起请求\n",
    "r = requests.get(url=geo_url,params = payload)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "5880a93b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "5a4b8ed9",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'count': '1',\n",
       " 'geocodes': [{'formatted_address': '广东省广州市从化区温泉镇中心大学南方学院',\n",
       "   'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'citycode': '020',\n",
       "   'city': '广州市',\n",
       "   'district': '从化区',\n",
       "   'township': [],\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'adcode': '440117',\n",
       "   'street': [],\n",
       "   'number': [],\n",
       "   'location': '113.678280,23.628439',\n",
       "   'level': '兴趣点'}]}"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "e63b1df6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.678280,23.628439'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "广州南方学院_location = r.json()['geocodes'][0]['location']#取完0后变成字典，再取['location']\n",
    "广州南方学院_location"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0b886820",
   "metadata": {},
   "source": [
    "### 逆地理编码"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b6d12a9f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# extensions=base(默认)\n",
    "# 1.调用requests模块（google chrome浏览器）\n",
    "import requests\n",
    "\n",
    "# 2.请求方法：GET\n",
    "\n",
    "# 3.URL地址：https://restapi.amap.com/v3/geocode/regeo?parameters\n",
    "regeo_url = \"https://restapi.amap.com/v3/geocode/regeo?parameters\"\n",
    "\n",
    "# 4.准备参数，用于交换数据 payload\n",
    "payload ={\n",
    "    \"key\":\"b0121f143057c2f0c3607e48fe21bac9\",\n",
    "    \"location\":广州南方学院_location\n",
    "}\n",
    "\n",
    "# 5.发起请求\n",
    "r = requests.get(url=regeo_url,params = payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "410be0d7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "1aa5d5d8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'regeocode': {'addressComponent': {'city': '广州市',\n",
       "   'province': '广东省',\n",
       "   'adcode': '440117',\n",
       "   'district': '从化区',\n",
       "   'towncode': '440117100000',\n",
       "   'streetNumber': {'number': '24号',\n",
       "    'location': '113.677267,23.629149',\n",
       "    'direction': '西北',\n",
       "    'distance': '129.943',\n",
       "    'street': '博学路'},\n",
       "   'country': '中国',\n",
       "   'township': '温泉镇',\n",
       "   'businessAreas': [[]],\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'citycode': '020'},\n",
       "  'formatted_address': '广东省广州市从化区温泉镇博学路广州南方学院'},\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000'}"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "0f71af63",
   "metadata": {},
   "outputs": [],
   "source": [
    "# extensions=all\n",
    "# 1.调用requests模块（google chrome浏览器）\n",
    "import requests\n",
    "\n",
    "# 2.请求方法：GET\n",
    "\n",
    "# 3.URL地址：https://restapi.amap.com/v3/geocode/regeo?parameters\n",
    "regeo_url = \"https://restapi.amap.com/v3/geocode/regeo?parameters\"\n",
    "\n",
    "# 4.准备参数，用于交换数据 payload\n",
    "payload ={\n",
    "    \"key\":\"b0121f143057c2f0c3607e48fe21bac9\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"extensions\":\"all\",\n",
    "    \"poitype\":\"true\"\n",
    "}\n",
    "\n",
    "# 5.发起请求\n",
    "r = requests.get(url=regeo_url,params = payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "9f3d1d69",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "cda32dda",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'regeocode': {'formatted_address': '广东省广州市从化区温泉镇博学路广州南方学院',\n",
       "  'addressComponent': {'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'city': '广州市',\n",
       "   'citycode': '020',\n",
       "   'district': '从化区',\n",
       "   'adcode': '440117',\n",
       "   'township': '温泉镇',\n",
       "   'towncode': '440117100000',\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'streetNumber': {'street': '博学路',\n",
       "    'number': '24号',\n",
       "    'location': '113.677267,23.629149',\n",
       "    'direction': '西北',\n",
       "    'distance': '129.943'},\n",
       "   'businessAreas': [[]]},\n",
       "  'pois': [{'id': 'B00140MR9A',\n",
       "    'name': '广州南方学院',\n",
       "    'type': '科教文化服务;学校;高等院校',\n",
       "    'tel': '020-87828988;020-61787331',\n",
       "    'direction': '北',\n",
       "    'distance': '470.792',\n",
       "    'location': '113.679257,23.632577',\n",
       "    'address': '温泉大道882号',\n",
       "    'poiweight': '0.450402',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFG4TAF2',\n",
       "    'name': '广州南方公寓',\n",
       "    'type': '商务住宅;商务住宅相关;商务住宅相关',\n",
       "    'tel': '13622768437',\n",
       "    'direction': '东南',\n",
       "    'distance': '102.617',\n",
       "    'location': '113.678983,23.627778',\n",
       "    'address': '温泉镇乌土村松浪队5号(近博学路)',\n",
       "    'poiweight': '0.237309',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0H6FA18J5',\n",
       "    'name': '保利半山花园',\n",
       "    'type': '商务住宅;住宅区;住宅区',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '139.054',\n",
       "    'location': '113.679358,23.627672',\n",
       "    'address': '从莞深高速(广州南方学院南侧)',\n",
       "    'poiweight': '0.223065',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B00140TWHT',\n",
       "    'name': '教工住宅1号',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '222.658',\n",
       "    'location': '113.678490,23.630432',\n",
       "    'address': '笃行路2',\n",
       "    'poiweight': '0.157653',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFHRJDM9',\n",
       "    'name': '中南公寓',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': '13711245345',\n",
       "    'direction': '东南',\n",
       "    'distance': '231.223',\n",
       "    'location': '113.680340,23.627566',\n",
       "    'address': '中大南方学院南门1号',\n",
       "    'poiweight': '0.256152',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD588HJ',\n",
       "    'name': '广州南方学院教学楼4号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '242.901',\n",
       "    'location': '113.677460,23.630490',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFHZH0IK',\n",
       "    'name': '地下铁',\n",
       "    'type': '餐饮服务;冷饮店;冷饮店',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '74.1376',\n",
       "    'location': '113.677941,23.629029',\n",
       "    'address': '博学路广州南方学院综合楼内',\n",
       "    'poiweight': '0.17934',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU76L2',\n",
       "    'name': '广州南方学院2号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '280.003',\n",
       "    'location': '113.678211,23.630956',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKP838K',\n",
       "    'name': '教学楼3号(外国语学院)',\n",
       "    'type': '科教文化服务;学校;高等院校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '298.093',\n",
       "    'location': '113.677247,23.630947',\n",
       "    'address': '博学路25',\n",
       "    'poiweight': '0.191742',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKSF1FI',\n",
       "    'name': '香辣螺蛳粉',\n",
       "    'type': '餐饮服务;餐饮相关场所;餐饮相关',\n",
       "    'tel': '17820061022',\n",
       "    'direction': '西',\n",
       "    'distance': '209.206',\n",
       "    'location': '113.676231,23.628565',\n",
       "    'address': '广州南方学院西4123',\n",
       "    'poiweight': '0.209252',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU8NLD',\n",
       "    'name': '广州南方学院1号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '326.007',\n",
       "    'location': '113.678215,23.631370',\n",
       "    'address': '博学路附近',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFLF90I2',\n",
       "    'name': '煌上煌酱鸭(南方学院店)',\n",
       "    'type': '餐饮服务;快餐厅;快餐厅',\n",
       "    'tel': '13712317721',\n",
       "    'direction': '东北',\n",
       "    'distance': '256.772',\n",
       "    'location': '113.679965,23.630156',\n",
       "    'address': '笃行路20、22、24号广州南方学院商业中心1层1F015',\n",
       "    'poiweight': '0.209448',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58UTU',\n",
       "    'name': '广州南方学院2号教学楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '346.352',\n",
       "    'location': '113.677060,23.631346',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.191229',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0H25SMRKP',\n",
       "    'name': '广州南方学院大礼堂',\n",
       "    'type': '科教文化服务;会展中心;会展中心',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '386.65',\n",
       "    'location': '113.680076,23.631502',\n",
       "    'address': '温泉大道882号',\n",
       "    'poiweight': '0.261624',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU92JD',\n",
       "    'name': '广州南方学院教学楼1号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '391.548',\n",
       "    'location': '113.677077,23.631783',\n",
       "    'address': '博学路19号',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD592BJ',\n",
       "    'name': '广州南方学院综合楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '392.731',\n",
       "    'location': '113.680117,23.631544',\n",
       "    'address': '温泉大道886号广州南方学院内',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKP81F0',\n",
       "    'name': '教学楼1号(文学与传媒学院)',\n",
       "    'type': '科教文化服务;科教文化场所;科教文化场所',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '393.93',\n",
       "    'location': '113.676866,23.631736',\n",
       "    'address': '博学路19号附近',\n",
       "    'poiweight': '0.191742',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFLBEOND',\n",
       "    'name': '聚贤楼10号',\n",
       "    'type': '商务住宅;住宅区;宿舍',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '418.51',\n",
       "    'location': '113.681253,23.631036',\n",
       "    'address': '从莞深高速(广州南方学院)',\n",
       "    'poiweight': '0.190963',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFH6K3U9',\n",
       "    'name': '广州中大南方招待所',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': '020-61787222',\n",
       "    'direction': '西北',\n",
       "    'distance': '378.102',\n",
       "    'location': '113.676330,23.631332',\n",
       "    'address': '温泉镇温泉大道882号广州南方学院H7栋1-5层',\n",
       "    'poiweight': '0.254885',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58NF8',\n",
       "    'name': '广州南方学院达人书院',\n",
       "    'type': '科教文化服务;科教文化场所;科教文化场所',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '446.366',\n",
       "    'location': '113.679041,23.632392',\n",
       "    'address': '温泉大道882号广州南方学院新综合楼2层',\n",
       "    'poiweight': '0.191229',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKUVYWV',\n",
       "    'name': '广州和风庭阿七度假别墅',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '424.35',\n",
       "    'location': '113.681736,23.630569',\n",
       "    'address': '保利桃花源',\n",
       "    'poiweight': '0.273168',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU99RM',\n",
       "    'name': '广州南方学院图书馆',\n",
       "    'type': '科教文化服务;图书馆;图书馆',\n",
       "    'tel': '020-61787368;020-61787371',\n",
       "    'direction': '北',\n",
       "    'distance': '489.331',\n",
       "    'location': '113.679177,23.632762',\n",
       "    'address': '温泉大道882号广州南方学院内',\n",
       "    'poiweight': '0.257947',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU92JC',\n",
       "    'name': '广州南方学院4号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '498.883',\n",
       "    'location': '113.679963,23.632652',\n",
       "    'address': '博学路附近',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFL7C054',\n",
       "    'name': '广州U优森特酒店',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': '15813395296',\n",
       "    'direction': '北',\n",
       "    'distance': '464.819',\n",
       "    'location': '113.679226,23.632528',\n",
       "    'address': '温泉镇博学路882号(广州南方学院商业中心1层)',\n",
       "    'poiweight': '0.317505',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFG8CSEK',\n",
       "    'name': 'L5员工宿舍',\n",
       "    'type': '商务住宅;住宅区;宿舍',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '554.129',\n",
       "    'location': '113.682583,23.631487',\n",
       "    'address': '从莞深高速(广州南方学院)',\n",
       "    'poiweight': '0.185371',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58FR2',\n",
       "    'name': '广州南方学院教学楼9号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '532.163',\n",
       "    'location': '113.679747,23.633032',\n",
       "    'address': '广州南方学院',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HG5Z9JNK',\n",
       "    'name': '广州南方学院教学楼7号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '544.868',\n",
       "    'location': '113.678600,23.633330',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221553',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD599JM',\n",
       "    'name': '广州南方学院第11教学楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '556.036',\n",
       "    'location': '113.680037,23.633173',\n",
       "    'address': '温泉大道882号广州南方学院',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0GUJYPEG2',\n",
       "    'name': '怒烤烤串(从化店)',\n",
       "    'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '510.112',\n",
       "    'location': '113.677160,23.632910',\n",
       "    'address': '温泉大道882号广州南方学院内博学路6号之3',\n",
       "    'poiweight': '0.216026',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU6Z41',\n",
       "    'name': '广州南方学院教学楼6号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '586.331',\n",
       "    'location': '113.678424,23.633710',\n",
       "    'address': '温泉大道882',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []}],\n",
       "  'roads': [{'id': '020F49F0050461206',\n",
       "    'name': '博学路',\n",
       "    'direction': '北',\n",
       "    'distance': '7.63232',\n",
       "    'location': '113.678,23.6284'},\n",
       "   {'id': '020F49F0050462229',\n",
       "    'name': '老虎形街',\n",
       "    'direction': '北',\n",
       "    'distance': '445.159',\n",
       "    'location': '113.679,23.6245'},\n",
       "   {'id': '020F49F0050462451',\n",
       "    'name': '中山路',\n",
       "    'direction': '南',\n",
       "    'distance': '708.299',\n",
       "    'location': '113.677,23.6347'}],\n",
       "  'roadinters': [{'direction': '南',\n",
       "    'distance': '708.299',\n",
       "    'location': '113.676794,23.634661',\n",
       "    'first_id': '020F49F0050461206',\n",
       "    'first_name': '博学路',\n",
       "    'second_id': '020F49F0050462451',\n",
       "    'second_name': '中山路'}],\n",
       "  'aois': [{'id': 'B00140MR9A',\n",
       "    'name': '广州南方学院',\n",
       "    'adcode': '440117',\n",
       "    'location': '113.679257,23.632577',\n",
       "    'area': '528560.656426',\n",
       "    'distance': '0',\n",
       "    'type': '141201'}]}}"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "791434bf",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "cdb5833b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>20</th>\n",
       "      <th>21</th>\n",
       "      <th>22</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "      <th>25</th>\n",
       "      <th>26</th>\n",
       "      <th>27</th>\n",
       "      <th>28</th>\n",
       "      <th>29</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>B00140MR9A</td>\n",
       "      <td>B0FFG4TAF2</td>\n",
       "      <td>B0H6FA18J5</td>\n",
       "      <td>B00140TWHT</td>\n",
       "      <td>B0FFHRJDM9</td>\n",
       "      <td>B0HGD588HJ</td>\n",
       "      <td>B0FFHZH0IK</td>\n",
       "      <td>B0HGDU76L2</td>\n",
       "      <td>B0FFKP838K</td>\n",
       "      <td>B0FFKSF1FI</td>\n",
       "      <td>...</td>\n",
       "      <td>B0FFKUVYWV</td>\n",
       "      <td>B0HGDU99RM</td>\n",
       "      <td>B0HGDU92JC</td>\n",
       "      <td>B0FFL7C054</td>\n",
       "      <td>B0FFG8CSEK</td>\n",
       "      <td>B0HGD58FR2</td>\n",
       "      <td>B0HG5Z9JNK</td>\n",
       "      <td>B0HGD599JM</td>\n",
       "      <td>B0GUJYPEG2</td>\n",
       "      <td>B0HGDU6Z41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <td>广州南方学院</td>\n",
       "      <td>广州南方公寓</td>\n",
       "      <td>保利半山花园</td>\n",
       "      <td>教工住宅1号</td>\n",
       "      <td>中南公寓</td>\n",
       "      <td>广州南方学院教学楼4号</td>\n",
       "      <td>地下铁</td>\n",
       "      <td>广州南方学院2号实验楼</td>\n",
       "      <td>教学楼3号(外国语学院)</td>\n",
       "      <td>香辣螺蛳粉</td>\n",
       "      <td>...</td>\n",
       "      <td>广州和风庭阿七度假别墅</td>\n",
       "      <td>广州南方学院图书馆</td>\n",
       "      <td>广州南方学院4号实验楼</td>\n",
       "      <td>广州U优森特酒店</td>\n",
       "      <td>L5员工宿舍</td>\n",
       "      <td>广州南方学院教学楼9号</td>\n",
       "      <td>广州南方学院教学楼7号</td>\n",
       "      <td>广州南方学院第11教学楼</td>\n",
       "      <td>怒烤烤串(从化店)</td>\n",
       "      <td>广州南方学院教学楼6号</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>type</th>\n",
       "      <td>科教文化服务;学校;高等院校</td>\n",
       "      <td>商务住宅;商务住宅相关;商务住宅相关</td>\n",
       "      <td>商务住宅;住宅区;住宅区</td>\n",
       "      <td>商务住宅;住宅区;住宅小区</td>\n",
       "      <td>商务住宅;住宅区;住宅小区</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>餐饮服务;冷饮店;冷饮店</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>科教文化服务;学校;高等院校</td>\n",
       "      <td>餐饮服务;餐饮相关场所;餐饮相关</td>\n",
       "      <td>...</td>\n",
       "      <td>住宿服务;住宿服务相关;住宿服务相关</td>\n",
       "      <td>科教文化服务;图书馆;图书馆</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>住宿服务;住宿服务相关;住宿服务相关</td>\n",
       "      <td>商务住宅;住宅区;宿舍</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tel</th>\n",
       "      <td>020-87828988;020-61787331</td>\n",
       "      <td>13622768437</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>13711245345</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>17820061022</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>020-61787368;020-61787371</td>\n",
       "      <td>[]</td>\n",
       "      <td>15813395296</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>direction</th>\n",
       "      <td>北</td>\n",
       "      <td>东南</td>\n",
       "      <td>东南</td>\n",
       "      <td>北</td>\n",
       "      <td>东南</td>\n",
       "      <td>北</td>\n",
       "      <td>西北</td>\n",
       "      <td>北</td>\n",
       "      <td>北</td>\n",
       "      <td>西</td>\n",
       "      <td>...</td>\n",
       "      <td>东北</td>\n",
       "      <td>北</td>\n",
       "      <td>北</td>\n",
       "      <td>北</td>\n",
       "      <td>东北</td>\n",
       "      <td>北</td>\n",
       "      <td>北</td>\n",
       "      <td>北</td>\n",
       "      <td>北</td>\n",
       "      <td>北</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>distance</th>\n",
       "      <td>470.792</td>\n",
       "      <td>102.617</td>\n",
       "      <td>139.054</td>\n",
       "      <td>222.658</td>\n",
       "      <td>231.223</td>\n",
       "      <td>242.901</td>\n",
       "      <td>74.1376</td>\n",
       "      <td>280.003</td>\n",
       "      <td>298.093</td>\n",
       "      <td>209.206</td>\n",
       "      <td>...</td>\n",
       "      <td>424.35</td>\n",
       "      <td>489.331</td>\n",
       "      <td>498.883</td>\n",
       "      <td>464.819</td>\n",
       "      <td>554.129</td>\n",
       "      <td>532.163</td>\n",
       "      <td>544.868</td>\n",
       "      <td>556.036</td>\n",
       "      <td>510.112</td>\n",
       "      <td>586.331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>location</th>\n",
       "      <td>113.679257,23.632577</td>\n",
       "      <td>113.678983,23.627778</td>\n",
       "      <td>113.679358,23.627672</td>\n",
       "      <td>113.678490,23.630432</td>\n",
       "      <td>113.680340,23.627566</td>\n",
       "      <td>113.677460,23.630490</td>\n",
       "      <td>113.677941,23.629029</td>\n",
       "      <td>113.678211,23.630956</td>\n",
       "      <td>113.677247,23.630947</td>\n",
       "      <td>113.676231,23.628565</td>\n",
       "      <td>...</td>\n",
       "      <td>113.681736,23.630569</td>\n",
       "      <td>113.679177,23.632762</td>\n",
       "      <td>113.679963,23.632652</td>\n",
       "      <td>113.679226,23.632528</td>\n",
       "      <td>113.682583,23.631487</td>\n",
       "      <td>113.679747,23.633032</td>\n",
       "      <td>113.678600,23.633330</td>\n",
       "      <td>113.680037,23.633173</td>\n",
       "      <td>113.677160,23.632910</td>\n",
       "      <td>113.678424,23.633710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>address</th>\n",
       "      <td>温泉大道882号</td>\n",
       "      <td>温泉镇乌土村松浪队5号(近博学路)</td>\n",
       "      <td>从莞深高速(广州南方学院南侧)</td>\n",
       "      <td>笃行路2</td>\n",
       "      <td>中大南方学院南门1号</td>\n",
       "      <td>博学路</td>\n",
       "      <td>博学路广州南方学院综合楼内</td>\n",
       "      <td>博学路</td>\n",
       "      <td>博学路25</td>\n",
       "      <td>广州南方学院西4123</td>\n",
       "      <td>...</td>\n",
       "      <td>保利桃花源</td>\n",
       "      <td>温泉大道882号广州南方学院内</td>\n",
       "      <td>博学路附近</td>\n",
       "      <td>温泉镇博学路882号(广州南方学院商业中心1层)</td>\n",
       "      <td>从莞深高速(广州南方学院)</td>\n",
       "      <td>广州南方学院</td>\n",
       "      <td>博学路</td>\n",
       "      <td>温泉大道882号广州南方学院</td>\n",
       "      <td>温泉大道882号广州南方学院内博学路6号之3</td>\n",
       "      <td>温泉大道882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>poiweight</th>\n",
       "      <td>0.450402</td>\n",
       "      <td>0.237309</td>\n",
       "      <td>0.223065</td>\n",
       "      <td>0.157653</td>\n",
       "      <td>0.256152</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>0.17934</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>0.191742</td>\n",
       "      <td>0.209252</td>\n",
       "      <td>...</td>\n",
       "      <td>0.273168</td>\n",
       "      <td>0.257947</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>0.317505</td>\n",
       "      <td>0.185371</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>0.221553</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>0.216026</td>\n",
       "      <td>0.221662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessarea</th>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     0                     1   \\\n",
       "id                           B00140MR9A            B0FFG4TAF2   \n",
       "name                             广州南方学院                广州南方公寓   \n",
       "type                     科教文化服务;学校;高等院校    商务住宅;商务住宅相关;商务住宅相关   \n",
       "tel           020-87828988;020-61787331           13622768437   \n",
       "direction                             北                    东南   \n",
       "distance                        470.792               102.617   \n",
       "location           113.679257,23.632577  113.678983,23.627778   \n",
       "address                        温泉大道882号     温泉镇乌土村松浪队5号(近博学路)   \n",
       "poiweight                      0.450402              0.237309   \n",
       "businessarea                         []                    []   \n",
       "\n",
       "                                2                     3   \\\n",
       "id                      B0H6FA18J5            B00140TWHT   \n",
       "name                        保利半山花园                教工住宅1号   \n",
       "type                  商务住宅;住宅区;住宅区         商务住宅;住宅区;住宅小区   \n",
       "tel                             []                    []   \n",
       "direction                       东南                     北   \n",
       "distance                   139.054               222.658   \n",
       "location      113.679358,23.627672  113.678490,23.630432   \n",
       "address            从莞深高速(广州南方学院南侧)                  笃行路2   \n",
       "poiweight                 0.223065              0.157653   \n",
       "businessarea                    []                    []   \n",
       "\n",
       "                                4                     5   \\\n",
       "id                      B0FFHRJDM9            B0HGD588HJ   \n",
       "name                          中南公寓           广州南方学院教学楼4号   \n",
       "type                 商务住宅;住宅区;住宅小区          科教文化服务;学校;学校   \n",
       "tel                    13711245345                    []   \n",
       "direction                       东南                     北   \n",
       "distance                   231.223               242.901   \n",
       "location      113.680340,23.627566  113.677460,23.630490   \n",
       "address                 中大南方学院南门1号                   博学路   \n",
       "poiweight                 0.256152              0.221662   \n",
       "businessarea                    []                    []   \n",
       "\n",
       "                                6                     7   \\\n",
       "id                      B0FFHZH0IK            B0HGDU76L2   \n",
       "name                           地下铁           广州南方学院2号实验楼   \n",
       "type                  餐饮服务;冷饮店;冷饮店          科教文化服务;学校;学校   \n",
       "tel                             []                    []   \n",
       "direction                       西北                     北   \n",
       "distance                   74.1376               280.003   \n",
       "location      113.677941,23.629029  113.678211,23.630956   \n",
       "address              博学路广州南方学院综合楼内                   博学路   \n",
       "poiweight                  0.17934              0.221662   \n",
       "businessarea                    []                    []   \n",
       "\n",
       "                                8                     9   ...  \\\n",
       "id                      B0FFKP838K            B0FFKSF1FI  ...   \n",
       "name                  教学楼3号(外国语学院)                 香辣螺蛳粉  ...   \n",
       "type                科教文化服务;学校;高等院校      餐饮服务;餐饮相关场所;餐饮相关  ...   \n",
       "tel                             []           17820061022  ...   \n",
       "direction                        北                     西  ...   \n",
       "distance                   298.093               209.206  ...   \n",
       "location      113.677247,23.630947  113.676231,23.628565  ...   \n",
       "address                      博学路25           广州南方学院西4123  ...   \n",
       "poiweight                 0.191742              0.209252  ...   \n",
       "businessarea                    []                    []  ...   \n",
       "\n",
       "                                20                         21  \\\n",
       "id                      B0FFKUVYWV                 B0HGDU99RM   \n",
       "name                   广州和风庭阿七度假别墅                  广州南方学院图书馆   \n",
       "type            住宿服务;住宿服务相关;住宿服务相关             科教文化服务;图书馆;图书馆   \n",
       "tel                             []  020-61787368;020-61787371   \n",
       "direction                       东北                          北   \n",
       "distance                    424.35                    489.331   \n",
       "location      113.681736,23.630569       113.679177,23.632762   \n",
       "address                      保利桃花源            温泉大道882号广州南方学院内   \n",
       "poiweight                 0.273168                   0.257947   \n",
       "businessarea                    []                         []   \n",
       "\n",
       "                                22                        23  \\\n",
       "id                      B0HGDU92JC                B0FFL7C054   \n",
       "name                   广州南方学院4号实验楼                  广州U优森特酒店   \n",
       "type                  科教文化服务;学校;学校        住宿服务;住宿服务相关;住宿服务相关   \n",
       "tel                             []               15813395296   \n",
       "direction                        北                         北   \n",
       "distance                   498.883                   464.819   \n",
       "location      113.679963,23.632652      113.679226,23.632528   \n",
       "address                      博学路附近  温泉镇博学路882号(广州南方学院商业中心1层)   \n",
       "poiweight                 0.221662                  0.317505   \n",
       "businessarea                    []                        []   \n",
       "\n",
       "                                24                    25  \\\n",
       "id                      B0FFG8CSEK            B0HGD58FR2   \n",
       "name                        L5员工宿舍           广州南方学院教学楼9号   \n",
       "type                   商务住宅;住宅区;宿舍          科教文化服务;学校;学校   \n",
       "tel                             []                    []   \n",
       "direction                       东北                     北   \n",
       "distance                   554.129               532.163   \n",
       "location      113.682583,23.631487  113.679747,23.633032   \n",
       "address              从莞深高速(广州南方学院)                广州南方学院   \n",
       "poiweight                 0.185371              0.221662   \n",
       "businessarea                    []                    []   \n",
       "\n",
       "                                26                    27  \\\n",
       "id                      B0HG5Z9JNK            B0HGD599JM   \n",
       "name                   广州南方学院教学楼7号          广州南方学院第11教学楼   \n",
       "type                  科教文化服务;学校;学校          科教文化服务;学校;学校   \n",
       "tel                             []                    []   \n",
       "direction                        北                     北   \n",
       "distance                   544.868               556.036   \n",
       "location      113.678600,23.633330  113.680037,23.633173   \n",
       "address                        博学路        温泉大道882号广州南方学院   \n",
       "poiweight                 0.221553              0.221662   \n",
       "businessarea                    []                    []   \n",
       "\n",
       "                                  28                    29  \n",
       "id                        B0GUJYPEG2            B0HGDU6Z41  \n",
       "name                       怒烤烤串(从化店)           广州南方学院教学楼6号  \n",
       "type              餐饮服务;中餐厅;特色/地方风味餐厅          科教文化服务;学校;学校  \n",
       "tel                               []                    []  \n",
       "direction                          北                     北  \n",
       "distance                     510.112               586.331  \n",
       "location        113.677160,23.632910  113.678424,23.633710  \n",
       "address       温泉大道882号广州南方学院内博学路6号之3               温泉大道882  \n",
       "poiweight                   0.216026              0.221662  \n",
       "businessarea                      []                    []  \n",
       "\n",
       "[10 rows x 30 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(r.json()['regeocode']['pois']).T"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "430ec686",
   "metadata": {},
   "source": [
    "### 搜索POI\n",
    "> 关键词方法\n",
    "> 分类types方法"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "d2a80e6c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 关键词方法\n",
    "# 1.调用requests模块（google chrome浏览器）\n",
    "import requests\n",
    "\n",
    "# 2.请求方法：GET\n",
    "\n",
    "# 3.URL地址：https://restapi.amap.com/v3/place/around?parameters \n",
    "regeo_url = \"https://restapi.amap.com/v3/place/around?parameters\"\n",
    "\n",
    "# 4.准备参数，用于交换数据 payload\n",
    "payload ={\n",
    "    \"key\":\"b0121f143057c2f0c3607e48fe21bac9\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"keywords\":\"中餐厅\",\n",
    "    \"page\":3\n",
    "}\n",
    "\n",
    "# 5.发起请求\n",
    "r = requests.get(url=regeo_url,params = payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "2bebebd0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'suggestion': {'keywords': [], 'cities': []},\n",
       " 'count': '235',\n",
       " 'infocode': '10000',\n",
       " 'pois': [{'parent': [],\n",
       "   'address': '广东省广州市从化区温泉镇金鸡村',\n",
       "   'distance': '1685',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.9',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/e1fbce962152269ce8e8337439faf543'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/93189de5d7da3e16ec5ee45138b49459'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/bcd951f0b726f17fe1128035036decab'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '小萌牛全民总动员',\n",
       "   'location': '113.677109,23.613332',\n",
       "   'tel': '15813351058',\n",
       "   'shopid': [],\n",
       "   'id': 'B0GUDHQSG9'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉大道(中山大学旁)卫东村卫东村委南侧50米处',\n",
       "   'distance': '2149',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '84.00',\n",
       "    'opentime2': [],\n",
       "    'rating': '4.5',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/a1a2e0ce8f90341a6ed407191ba219ff'},\n",
       "    {'title': [],\n",
       "     'url': 'http://aos-cdn-image.amap.com/sns/ugccomment/057b0581-fed7-4665-906e-7c268f5a59c5.jpg'},\n",
       "    {'title': [],\n",
       "     'url': 'http://aos-cdn-image.amap.com/sns/ugccomment/c7aefe58-08ee-4f2d-aecd-f5cf512c31a6.jpg'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '卫东农庄',\n",
       "   'location': '113.677608,23.647740',\n",
       "   'tel': '020-37977399',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFGKX9PY'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇永福新村5号',\n",
       "   'distance': '2228',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '72.00',\n",
       "    'opentime2': [],\n",
       "    'rating': '4.2',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/e305075a91afdc955a0f7019eeb828bd'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/84f0b0637def8d4833a90ec39502e4fa'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/222c7b0d4cd7d7dc8aa5f16b4c4ad457'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '凤仙餐馆',\n",
       "   'location': '113.661270,23.640879',\n",
       "   'tel': '020-87838990',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFHE66RZ'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇永福邨B座9-10号',\n",
       "   'distance': '2266',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '48.00',\n",
       "    'opentime2': '10:30-14:00；16:00-23:00',\n",
       "    'rating': '4.8',\n",
       "    'open_time': '10:30-14:00 16:00-23:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/6b93aa1a74a1aaf5a3642b145c680ff2'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/1b7047e16ead7cd033fa5e402727a145'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/1e1b784bea702c98474a93a8a7fc6c77'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '仙溪美食农庄20年老字号(温泉镇店)',\n",
       "   'location': '113.660610,23.640756',\n",
       "   'tel': '13725183498',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFFAIVRY'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇永福路1号永福漫街A区3楼301-302',\n",
       "   'distance': '2312',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '17:30-01:30',\n",
       "    'rating': '4.0',\n",
       "    'open_time': '17:30-01:30',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/d4bed1302ad3537e94ec4af7aaebc55c'},\n",
       "    {'title': [],\n",
       "     'url': 'http://aos-cdn-image.amap.com/sns/ugccomment/202843a8-75dd-4d2e-98c4-213a74192166.jpg'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '空中之声烧烤吧',\n",
       "   'location': '113.659544,23.640329',\n",
       "   'tel': '13926235161',\n",
       "   'shopid': [],\n",
       "   'id': 'B0GK4ORPPU'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇永福漫街A区2楼',\n",
       "   'distance': '2318',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '56.00',\n",
       "    'opentime2': '10:00-22:00',\n",
       "    'rating': '4.4',\n",
       "    'open_time': '10:00-22:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/2044a40b170256a5fb05299e3af9f175'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/4f47d23da7c0958622760a4035567ee3'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/e017c519fb053cbf01614bf6bbb0fffa'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '温陶居私房菜',\n",
       "   'location': '113.659697,23.640419',\n",
       "   'tel': '13925068523',\n",
       "   'shopid': [],\n",
       "   'id': 'B0G304EZT6'},\n",
       "  {'parent': [],\n",
       "   'address': '源湖前街与龙泉路交叉口东南约220米',\n",
       "   'distance': '2363',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.9',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '荔蜜园餐厅',\n",
       "   'location': '113.662858,23.612591',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B00141JCPD'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇亨来斯登酒店',\n",
       "   'distance': '2403',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '2.4',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '德州烧烤(中大店)',\n",
       "   'location': '113.658707,23.640472',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCKB60'},\n",
       "  {'parent': 'B0G1GMN7P5',\n",
       "   'address': '温泉镇亨来斯登酒店',\n",
       "   'distance': '2403',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '2.3',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': '324',\n",
       "   'adname': '从化区',\n",
       "   'name': '和记烧烤(中大店)',\n",
       "   'location': '113.658707,23.640472',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1M7Y7LR'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉东路1号(加油站斜坡隔壁)',\n",
       "   'distance': '2406',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '58.00',\n",
       "    'opentime2': '10:00-14:00；16:30-01:30',\n",
       "    'rating': '4.3',\n",
       "    'open_time': '10:00-14:00 16:30-01:30',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;广东菜(粤菜)',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/071726c1bd55bfe415522a316aad580d'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/b80d1a1da127837c7ffcf654d25802b4'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/a66185881412fc05d73fce7b318b35e2'}],\n",
       "   'typecode': '050103',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '品味烧鸡天下菜馆',\n",
       "   'location': '113.658187,23.639770',\n",
       "   'tel': '020-37502123',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFGW1SIX'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇景泉大道伟腾电脑旁',\n",
       "   'distance': '2426',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '67.00',\n",
       "    'opentime2': '10:00-03:00',\n",
       "    'rating': '4.4',\n",
       "    'open_time': '10:00-03:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/6541c2f146dbdba86df8c4e2ca05d296'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/01136c2c4b31bf9169c14a5cb115fcfd'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/204f0db8a4669b63e4d347ca7dda90df'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '壹哥私厨',\n",
       "   'location': '113.658081,23.639960',\n",
       "   'tel': '020-87838600',\n",
       "   'shopid': [],\n",
       "   'id': 'B0GKZU9Y2N'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉东路2号',\n",
       "   'distance': '2436',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '47.00',\n",
       "    'opentime2': [],\n",
       "    'rating': '3.9',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/0acd8dc2d09e9e1460891c592a80019f'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/1bb3e31a1d46d24403dfe08bd501eed3'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/f5671f3a8e9ac9b81ddc62b9597b4001'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': 'Y8约吧',\n",
       "   'location': '113.658463,23.640656',\n",
       "   'tel': '020-62163188',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFHKN3EN'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉东路15号',\n",
       "   'distance': '2441',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '4.2',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;湖南菜(湘菜)',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/54b4c98e87cb0c00047a94757dad5b3b'}],\n",
       "   'typecode': '050108',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '明厨湘菜馆',\n",
       "   'location': '113.657984,23.640078',\n",
       "   'tel': '18922734163',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFJWLNJU'},\n",
       "  {'parent': [],\n",
       "   'address': '福泉大街西四巷亨来斯登珍稀温泉养生酒店北侧约50米',\n",
       "   'distance': '2468',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.9',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;餐饮相关场所;餐饮相关',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/ea90f324a596f97d455e58cdbd180299'},\n",
       "    {'title': [],\n",
       "     'url': 'https://img.alicdn.com/imgextra/i3/3695320962/O1CN01FYTBYU1Iydi9Xtx9Y_!!3695320962-0-kbcontentapng.jpg'}],\n",
       "   'typecode': '050000',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '七星烧鸭(温泉店)',\n",
       "   'location': '113.658534,23.641270',\n",
       "   'tel': '13527704733',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFJOJ01Z'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉东路西四巷26号',\n",
       "   'distance': '2469',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '住家菜',\n",
       "   'location': '113.658390,23.641096',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0G3A4AK8S'},\n",
       "  {'parent': [],\n",
       "   'address': '河田村',\n",
       "   'distance': '3060',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '4.2',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/70640bebc6864f90742d3cbd08ef2e15'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/9d33ac702873bd0a1b271e73951f57d4'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/64780317b4571a62a206ae3839c0de3d'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '渔田农庄',\n",
       "   'location': '113.706528,23.619169',\n",
       "   'tel': '13533700299',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFI90BAF'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉东路99号',\n",
       "   'distance': '3060',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '53.00',\n",
       "    'opentime2': '10:00-21:00',\n",
       "    'rating': '4.6',\n",
       "    'open_time': '10:00-21:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/18132bec7fd836ec909aae4ad8d92e5f'},\n",
       "    {'title': '产品图',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/9d00e60d9421930c973d23c0ce6fd0fb'},\n",
       "    {'title': '产品图',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/c12a7ff8105dd732137d63da821b6a5e'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '幸福楼酒店(温泉东路)',\n",
       "   'location': '113.654186,23.644836',\n",
       "   'tel': '020-87838813;020-87838758',\n",
       "   'shopid': [],\n",
       "   'id': 'B00140FG8A'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉东路72号之三',\n",
       "   'distance': '3065',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '66.00',\n",
       "    'opentime2': '11:00-21:00',\n",
       "    'rating': '4.4',\n",
       "    'open_time': '11:00-21:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/4eb157c4d054bf3dc5f33608567f661a'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/e219a127124a5d1053efbf279bbb19a0'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/f898c678eec19e726da3a89588fd82c9'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '濠聚私厨·本地特色农家菜',\n",
       "   'location': '113.654488,23.645272',\n",
       "   'tel': '15915747589',\n",
       "   'shopid': [],\n",
       "   'id': 'B0H61CQ6N4'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉东路72号第五间铺',\n",
       "   'distance': '3076',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.9',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '肥仔美食店',\n",
       "   'location': '113.654221,23.645109',\n",
       "   'tel': '13926128676',\n",
       "   'shopid': [],\n",
       "   'id': 'B0HAGUVOAJ'},\n",
       "  {'parent': 'B0FFGIL2TX',\n",
       "   'address': '温泉东路73号(近碧泉路派出所)',\n",
       "   'distance': '3087',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.6',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': '202',\n",
       "   'adname': '从化区',\n",
       "   'name': '碧泉空中温泉宴会厅',\n",
       "   'location': '113.654907,23.646064',\n",
       "   'tel': '020-87839222',\n",
       "   'shopid': [],\n",
       "   'id': 'B00141VOBU'}],\n",
       " 'status': '1',\n",
       " 'info': 'OK'}"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "774dfeeb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>parent</th>\n",
       "      <th>address</th>\n",
       "      <th>distance</th>\n",
       "      <th>pname</th>\n",
       "      <th>importance</th>\n",
       "      <th>biz_type</th>\n",
       "      <th>cityname</th>\n",
       "      <th>type</th>\n",
       "      <th>photos</th>\n",
       "      <th>typecode</th>\n",
       "      <th>...</th>\n",
       "      <th>name</th>\n",
       "      <th>location</th>\n",
       "      <th>tel</th>\n",
       "      <th>shopid</th>\n",
       "      <th>id</th>\n",
       "      <th>biz_ext.cost</th>\n",
       "      <th>biz_ext.opentime2</th>\n",
       "      <th>biz_ext.rating</th>\n",
       "      <th>biz_ext.open_time</th>\n",
       "      <th>biz_ext.meal_ordering</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[]</td>\n",
       "      <td>广东省广州市从化区温泉镇金鸡村</td>\n",
       "      <td>1685</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>小萌牛全民总动员</td>\n",
       "      <td>113.677109,23.613332</td>\n",
       "      <td>15813351058</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0GUDHQSG9</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉大道(中山大学旁)卫东村卫东村委南侧50米处</td>\n",
       "      <td>2149</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>卫东农庄</td>\n",
       "      <td>113.677608,23.647740</td>\n",
       "      <td>020-37977399</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFGKX9PY</td>\n",
       "      <td>84.00</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.5</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇永福新村5号</td>\n",
       "      <td>2228</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>凤仙餐馆</td>\n",
       "      <td>113.661270,23.640879</td>\n",
       "      <td>020-87838990</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFHE66RZ</td>\n",
       "      <td>72.00</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇永福邨B座9-10号</td>\n",
       "      <td>2266</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>仙溪美食农庄20年老字号(温泉镇店)</td>\n",
       "      <td>113.660610,23.640756</td>\n",
       "      <td>13725183498</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFFAIVRY</td>\n",
       "      <td>48.00</td>\n",
       "      <td>10:30-14:00；16:00-23:00</td>\n",
       "      <td>4.8</td>\n",
       "      <td>10:30-14:00 16:00-23:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇永福路1号永福漫街A区3楼301-302</td>\n",
       "      <td>2312</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>空中之声烧烤吧</td>\n",
       "      <td>113.659544,23.640329</td>\n",
       "      <td>13926235161</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0GK4ORPPU</td>\n",
       "      <td>[]</td>\n",
       "      <td>17:30-01:30</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17:30-01:30</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇永福漫街A区2楼</td>\n",
       "      <td>2318</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>温陶居私房菜</td>\n",
       "      <td>113.659697,23.640419</td>\n",
       "      <td>13925068523</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G304EZT6</td>\n",
       "      <td>56.00</td>\n",
       "      <td>10:00-22:00</td>\n",
       "      <td>4.4</td>\n",
       "      <td>10:00-22:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[]</td>\n",
       "      <td>源湖前街与龙泉路交叉口东南约220米</td>\n",
       "      <td>2363</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>荔蜜园餐厅</td>\n",
       "      <td>113.662858,23.612591</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00141JCPD</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇亨来斯登酒店</td>\n",
       "      <td>2403</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>德州烧烤(中大店)</td>\n",
       "      <td>113.658707,23.640472</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCKB60</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.4</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>B0G1GMN7P5</td>\n",
       "      <td>温泉镇亨来斯登酒店</td>\n",
       "      <td>2403</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>和记烧烤(中大店)</td>\n",
       "      <td>113.658707,23.640472</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1M7Y7LR</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.3</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉东路1号(加油站斜坡隔壁)</td>\n",
       "      <td>2406</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;广东菜(粤菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050103</td>\n",
       "      <td>...</td>\n",
       "      <td>品味烧鸡天下菜馆</td>\n",
       "      <td>113.658187,23.639770</td>\n",
       "      <td>020-37502123</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFGW1SIX</td>\n",
       "      <td>58.00</td>\n",
       "      <td>10:00-14:00；16:30-01:30</td>\n",
       "      <td>4.3</td>\n",
       "      <td>10:00-14:00 16:30-01:30</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇景泉大道伟腾电脑旁</td>\n",
       "      <td>2426</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>壹哥私厨</td>\n",
       "      <td>113.658081,23.639960</td>\n",
       "      <td>020-87838600</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0GKZU9Y2N</td>\n",
       "      <td>67.00</td>\n",
       "      <td>10:00-03:00</td>\n",
       "      <td>4.4</td>\n",
       "      <td>10:00-03:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉东路2号</td>\n",
       "      <td>2436</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>Y8约吧</td>\n",
       "      <td>113.658463,23.640656</td>\n",
       "      <td>020-62163188</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFHKN3EN</td>\n",
       "      <td>47.00</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉东路15号</td>\n",
       "      <td>2441</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;湖南菜(湘菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050108</td>\n",
       "      <td>...</td>\n",
       "      <td>明厨湘菜馆</td>\n",
       "      <td>113.657984,23.640078</td>\n",
       "      <td>18922734163</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFJWLNJU</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>[]</td>\n",
       "      <td>福泉大街西四巷亨来斯登珍稀温泉养生酒店北侧约50米</td>\n",
       "      <td>2468</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;餐饮相关场所;餐饮相关</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050000</td>\n",
       "      <td>...</td>\n",
       "      <td>七星烧鸭(温泉店)</td>\n",
       "      <td>113.658534,23.641270</td>\n",
       "      <td>13527704733</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFJOJ01Z</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉东路西四巷26号</td>\n",
       "      <td>2469</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>住家菜</td>\n",
       "      <td>113.658390,23.641096</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G3A4AK8S</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>[]</td>\n",
       "      <td>河田村</td>\n",
       "      <td>3060</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>渔田农庄</td>\n",
       "      <td>113.706528,23.619169</td>\n",
       "      <td>13533700299</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFI90BAF</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉东路99号</td>\n",
       "      <td>3060</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>幸福楼酒店(温泉东路)</td>\n",
       "      <td>113.654186,23.644836</td>\n",
       "      <td>020-87838813;020-87838758</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00140FG8A</td>\n",
       "      <td>53.00</td>\n",
       "      <td>10:00-21:00</td>\n",
       "      <td>4.6</td>\n",
       "      <td>10:00-21:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉东路72号之三</td>\n",
       "      <td>3065</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>濠聚私厨·本地特色农家菜</td>\n",
       "      <td>113.654488,23.645272</td>\n",
       "      <td>15915747589</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H61CQ6N4</td>\n",
       "      <td>66.00</td>\n",
       "      <td>11:00-21:00</td>\n",
       "      <td>4.4</td>\n",
       "      <td>11:00-21:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉东路72号第五间铺</td>\n",
       "      <td>3076</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>肥仔美食店</td>\n",
       "      <td>113.654221,23.645109</td>\n",
       "      <td>13926128676</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HAGUVOAJ</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B0FFGIL2TX</td>\n",
       "      <td>温泉东路73号(近碧泉路派出所)</td>\n",
       "      <td>3087</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>碧泉空中温泉宴会厅</td>\n",
       "      <td>113.654907,23.646064</td>\n",
       "      <td>020-87839222</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00141VOBU</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.6</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        parent                    address distance pname importance biz_type  \\\n",
       "0           []            广东省广州市从化区温泉镇金鸡村     1685   广东省         []    diner   \n",
       "1           []   温泉大道(中山大学旁)卫东村卫东村委南侧50米处     2149   广东省         []    diner   \n",
       "2   B0G1GMN7P5                  温泉镇永福新村5号     2228   广东省         []    diner   \n",
       "3   B0G1GMN7P5              温泉镇永福邨B座9-10号     2266   广东省         []    diner   \n",
       "4   B0G1GMN7P5    温泉镇永福路1号永福漫街A区3楼301-302     2312   广东省         []    diner   \n",
       "5   B0G1GMN7P5                温泉镇永福漫街A区2楼     2318   广东省         []    diner   \n",
       "6           []         源湖前街与龙泉路交叉口东南约220米     2363   广东省         []    diner   \n",
       "7   B0G1GMN7P5                  温泉镇亨来斯登酒店     2403   广东省         []    diner   \n",
       "8   B0G1GMN7P5                  温泉镇亨来斯登酒店     2403   广东省         []    diner   \n",
       "9           []         温泉镇温泉东路1号(加油站斜坡隔壁)     2406   广东省         []    diner   \n",
       "10          []               温泉镇景泉大道伟腾电脑旁     2426   广东省         []    diner   \n",
       "11          []                     温泉东路2号     2436   广东省         []    diner   \n",
       "12          []                    温泉东路15号     2441   广东省         []    diner   \n",
       "13          []  福泉大街西四巷亨来斯登珍稀温泉养生酒店北侧约50米     2468   广东省         []    diner   \n",
       "14          []              温泉镇温泉东路西四巷26号     2469   广东省         []    diner   \n",
       "15          []                        河田村     3060   广东省         []    diner   \n",
       "16          []                 温泉镇温泉东路99号     3060   广东省         []    diner   \n",
       "17          []               温泉镇温泉东路72号之三     3065   广东省         []    diner   \n",
       "18          []             温泉镇温泉东路72号第五间铺     3076   广东省         []    diner   \n",
       "19  B0FFGIL2TX           温泉东路73号(近碧泉路派出所)     3087   广东省         []    diner   \n",
       "\n",
       "   cityname                type  \\\n",
       "0       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "1       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "2       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "3       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "4       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "5       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "6       广州市        餐饮服务;中餐厅;中餐厅   \n",
       "7       广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "8       广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "9       广州市    餐饮服务;中餐厅;广东菜(粤菜)   \n",
       "10      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "11      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "12      广州市    餐饮服务;中餐厅;湖南菜(湘菜)   \n",
       "13      广州市    餐饮服务;餐饮相关场所;餐饮相关   \n",
       "14      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "15      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "16      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "17      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "18      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "19      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "\n",
       "                                               photos typecode  ...  \\\n",
       "0   [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "1   [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "2   [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "3   [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "4   [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "5   [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "6                                                  []   050100  ...   \n",
       "7                                                  []   050118  ...   \n",
       "8                                                  []   050118  ...   \n",
       "9   [{'title': [], 'url': 'http://store.is.autonav...   050103  ...   \n",
       "10  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "11  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "12  [{'title': [], 'url': 'http://store.is.autonav...   050108  ...   \n",
       "13  [{'title': [], 'url': 'http://store.is.autonav...   050000  ...   \n",
       "14                                                 []   050100  ...   \n",
       "15  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "16  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "17  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "18                                                 []   050100  ...   \n",
       "19                                                 []   050100  ...   \n",
       "\n",
       "                  name              location                        tel  \\\n",
       "0             小萌牛全民总动员  113.677109,23.613332                15813351058   \n",
       "1                 卫东农庄  113.677608,23.647740               020-37977399   \n",
       "2                 凤仙餐馆  113.661270,23.640879               020-87838990   \n",
       "3   仙溪美食农庄20年老字号(温泉镇店)  113.660610,23.640756                13725183498   \n",
       "4              空中之声烧烤吧  113.659544,23.640329                13926235161   \n",
       "5               温陶居私房菜  113.659697,23.640419                13925068523   \n",
       "6                荔蜜园餐厅  113.662858,23.612591                         []   \n",
       "7            德州烧烤(中大店)  113.658707,23.640472                         []   \n",
       "8            和记烧烤(中大店)  113.658707,23.640472                         []   \n",
       "9             品味烧鸡天下菜馆  113.658187,23.639770               020-37502123   \n",
       "10                壹哥私厨  113.658081,23.639960               020-87838600   \n",
       "11                Y8约吧  113.658463,23.640656               020-62163188   \n",
       "12               明厨湘菜馆  113.657984,23.640078                18922734163   \n",
       "13           七星烧鸭(温泉店)  113.658534,23.641270                13527704733   \n",
       "14                 住家菜  113.658390,23.641096                         []   \n",
       "15                渔田农庄  113.706528,23.619169                13533700299   \n",
       "16         幸福楼酒店(温泉东路)  113.654186,23.644836  020-87838813;020-87838758   \n",
       "17        濠聚私厨·本地特色农家菜  113.654488,23.645272                15915747589   \n",
       "18               肥仔美食店  113.654221,23.645109                13926128676   \n",
       "19           碧泉空中温泉宴会厅  113.654907,23.646064               020-87839222   \n",
       "\n",
       "   shopid          id biz_ext.cost        biz_ext.opentime2 biz_ext.rating  \\\n",
       "0      []  B0GUDHQSG9           []                       []            3.9   \n",
       "1      []  B0FFGKX9PY        84.00                       []            4.5   \n",
       "2      []  B0FFHE66RZ        72.00                       []            4.2   \n",
       "3      []  B0FFFAIVRY        48.00  10:30-14:00；16:00-23:00            4.8   \n",
       "4      []  B0GK4ORPPU           []              17:30-01:30            4.0   \n",
       "5      []  B0G304EZT6        56.00              10:00-22:00            4.4   \n",
       "6      []  B00141JCPD           []                       []            3.9   \n",
       "7      []  B0HROCKB60           []                       []            2.4   \n",
       "8      []  B0H1M7Y7LR           []                       []            2.3   \n",
       "9      []  B0FFGW1SIX        58.00  10:00-14:00；16:30-01:30            4.3   \n",
       "10     []  B0GKZU9Y2N        67.00              10:00-03:00            4.4   \n",
       "11     []  B0FFHKN3EN        47.00                       []            3.9   \n",
       "12     []  B0FFJWLNJU           []                       []            4.2   \n",
       "13     []  B0FFJOJ01Z           []                       []            3.9   \n",
       "14     []  B0G3A4AK8S           []                       []             []   \n",
       "15     []  B0FFI90BAF           []                       []            4.2   \n",
       "16     []  B00140FG8A        53.00              10:00-21:00            4.6   \n",
       "17     []  B0H61CQ6N4        66.00              11:00-21:00            4.4   \n",
       "18     []  B0HAGUVOAJ           []                       []            3.9   \n",
       "19     []  B00141VOBU           []                       []            3.6   \n",
       "\n",
       "          biz_ext.open_time biz_ext.meal_ordering  \n",
       "0                        []                     0  \n",
       "1                        []                     0  \n",
       "2                        []                     0  \n",
       "3   10:30-14:00 16:00-23:00                     0  \n",
       "4               17:30-01:30                     0  \n",
       "5               10:00-22:00                     0  \n",
       "6                        []                     0  \n",
       "7                        []                     0  \n",
       "8                        []                     0  \n",
       "9   10:00-14:00 16:30-01:30                     0  \n",
       "10              10:00-03:00                     0  \n",
       "11                       []                     0  \n",
       "12                       []                     0  \n",
       "13                       []                     0  \n",
       "14                       []                     0  \n",
       "15                       []                     0  \n",
       "16              10:00-21:00                     0  \n",
       "17              11:00-21:00                     0  \n",
       "18                       []                     0  \n",
       "19                       []                     0  \n",
       "\n",
       "[20 rows x 24 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd.json_normalize(r.json()['pois'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "968c74cd",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 1.调用requests模块（google chrome浏览器）\n",
    "import requests\n",
    "\n",
    "# 2.请求方法：GET\n",
    "\n",
    "# 3.URL地址：https://restapi.amap.com/v3/place/around?parameters \n",
    "regeo_url = \"https://restapi.amap.com/v3/place/around?parameters\"\n",
    "\n",
    "# 4.准备参数，用于交换数据 payload\n",
    "payload ={\n",
    "    \"key\":\"b0121f143057c2f0c3607e48fe21bac9\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"types\":\"050100\",\n",
    "    \"pages\":2\n",
    "}\n",
    "\n",
    "# 5.发起请求\n",
    "r = requests.get(url=regeo_url,params = payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "284677bf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "4e6111fc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'suggestion': {'keywords': [], 'cities': []},\n",
       " 'count': '244',\n",
       " 'infocode': '10000',\n",
       " 'pois': [{'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院后门润泰超市首层01-02号商铺',\n",
       "   'distance': '18',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '我家卖米粉(中大店)',\n",
       "   'location': '113.678455,23.628393',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HRO7MT5G'},\n",
       "  {'parent': [],\n",
       "   'address': '博学路6号(广州南方学院南门口旁)',\n",
       "   'distance': '19',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '喜洋洋烧烤城',\n",
       "   'location': '113.678474,23.628422',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFKT56Q8'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院',\n",
       "   'distance': '130',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '港式住家饭(中大店)',\n",
       "   'location': '113.679504,23.628108',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1M90UGD'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方',\n",
       "   'distance': '146',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '找餐时间(轻食店)',\n",
       "   'location': '113.679695,23.628204',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H31YY48Q'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院',\n",
       "   'distance': '149',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '1号粥店',\n",
       "   'location': '113.679738,23.628307',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCMB8D'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方',\n",
       "   'distance': '150',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '巴老冒豆花冒菜(中大店)',\n",
       "   'location': '113.679739,23.628221',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCISXU'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院',\n",
       "   'distance': '156',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '牛哥烧烤',\n",
       "   'location': '113.679809,23.628326',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCM3MH'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇平岗村乌土平岗街29号',\n",
       "   'distance': '218',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '2.6',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '桃缘瓦舍',\n",
       "   'location': '113.680297,23.627788',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0IGC5BQCT'},\n",
       "  {'parent': [],\n",
       "   'address': '乌土村中南公寓',\n",
       "   'distance': '231',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '歡喜烤鱼饭',\n",
       "   'location': '113.680349,23.627573',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCIT9Q'},\n",
       "  {'parent': [],\n",
       "   'address': '中南公寓首层022铺',\n",
       "   'distance': '231',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '过桥米线',\n",
       "   'location': '113.680349,23.627573',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H11HOB7J'},\n",
       "  {'parent': [],\n",
       "   'address': '中大南方学院后门',\n",
       "   'distance': '239',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '2.7',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '99BARBECUE烤吧(中大店)',\n",
       "   'location': '113.680449,23.629268',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCMIX1'},\n",
       "  {'parent': [],\n",
       "   'address': '广州南方学院',\n",
       "   'distance': '261',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '09:00-23:00',\n",
       "    'rating': '4.5',\n",
       "    'open_time': '09:00-23:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;四川菜(川菜)',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/20080ba9f6fcd2808d64ce149b517ca9'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/9f40694ca108a175d36847d03ecf4ec0'},\n",
       "    {'title': [],\n",
       "     'url': 'https://img.alicdn.com/imgextra/i2/3695320962/O1CN01JFnmLv1IydhNhdLT4_!!3695320962-0-kbcontentapng.jpg'}],\n",
       "   'typecode': '050102',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '重庆湖边纸包鱼',\n",
       "   'location': '113.680073,23.630511',\n",
       "   'tel': '13924024938',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFL7NUA2'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇乌土村上围2队13号',\n",
       "   'distance': '268',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '壹休盖饭',\n",
       "   'location': '113.679611,23.630517',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HRHG0RSP'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇笃行路20、22、24号中山大学南方学院商业中心二楼022号',\n",
       "   'distance': '268',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '爱鱼者酸菜鱼饭(中大店)',\n",
       "   'location': '113.680193,23.630101',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1M7009J'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇笃行路',\n",
       "   'distance': '285',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '09:00-21:00',\n",
       "    'rating': '4.0',\n",
       "    'open_time': '09:00-21:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/69d57350187c929a96b7c77681c44cc2'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '筷乐逸家',\n",
       "   'location': '113.680147,23.630344',\n",
       "   'tel': '15811600514',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFL7CP5J'},\n",
       "  {'parent': [],\n",
       "   'address': '中山大学南方学院',\n",
       "   'distance': '320',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '桃姐靓汤(中大南方店)',\n",
       "   'location': '113.680188,23.630727',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HRO7LCM1'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉大道886号中山大学南方学院内',\n",
       "   'distance': '334',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '鱼家风范',\n",
       "   'location': '113.680590,23.630575',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCL270'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方学院',\n",
       "   'distance': '359',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '长沙一绝',\n",
       "   'location': '113.676568,23.631259',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCMY5T'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方学院',\n",
       "   'distance': '359',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '壹号饺子馆(中大店)',\n",
       "   'location': '113.676568,23.631259',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCL9C0'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉中大南方学院',\n",
       "   'distance': '359',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '淮南牛肉粉丝汤',\n",
       "   'location': '113.676568,23.631259',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCKTON'}],\n",
       " 'status': '1',\n",
       " 'info': 'OK'}"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "8b04b406",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>parent</th>\n",
       "      <th>address</th>\n",
       "      <th>distance</th>\n",
       "      <th>pname</th>\n",
       "      <th>importance</th>\n",
       "      <th>biz_type</th>\n",
       "      <th>cityname</th>\n",
       "      <th>type</th>\n",
       "      <th>photos</th>\n",
       "      <th>typecode</th>\n",
       "      <th>...</th>\n",
       "      <th>name</th>\n",
       "      <th>location</th>\n",
       "      <th>tel</th>\n",
       "      <th>shopid</th>\n",
       "      <th>id</th>\n",
       "      <th>biz_ext.cost</th>\n",
       "      <th>biz_ext.opentime2</th>\n",
       "      <th>biz_ext.rating</th>\n",
       "      <th>biz_ext.open_time</th>\n",
       "      <th>biz_ext.meal_ordering</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院后门润泰超市首层01-02号商铺</td>\n",
       "      <td>18</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>我家卖米粉(中大店)</td>\n",
       "      <td>113.678455,23.628393</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HRO7MT5G</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[]</td>\n",
       "      <td>博学路6号(广州南方学院南门口旁)</td>\n",
       "      <td>19</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>喜洋洋烧烤城</td>\n",
       "      <td>113.678474,23.628422</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFKT56Q8</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院</td>\n",
       "      <td>130</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>港式住家饭(中大店)</td>\n",
       "      <td>113.679504,23.628108</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1M90UGD</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方</td>\n",
       "      <td>146</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>找餐时间(轻食店)</td>\n",
       "      <td>113.679695,23.628204</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H31YY48Q</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院</td>\n",
       "      <td>149</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>1号粥店</td>\n",
       "      <td>113.679738,23.628307</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCMB8D</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方</td>\n",
       "      <td>150</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>巴老冒豆花冒菜(中大店)</td>\n",
       "      <td>113.679739,23.628221</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCISXU</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院</td>\n",
       "      <td>156</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>牛哥烧烤</td>\n",
       "      <td>113.679809,23.628326</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCM3MH</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇平岗村乌土平岗街29号</td>\n",
       "      <td>218</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>桃缘瓦舍</td>\n",
       "      <td>113.680297,23.627788</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0IGC5BQCT</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.6</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[]</td>\n",
       "      <td>乌土村中南公寓</td>\n",
       "      <td>231</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>歡喜烤鱼饭</td>\n",
       "      <td>113.680349,23.627573</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCIT9Q</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[]</td>\n",
       "      <td>中南公寓首层022铺</td>\n",
       "      <td>231</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>过桥米线</td>\n",
       "      <td>113.680349,23.627573</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H11HOB7J</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>[]</td>\n",
       "      <td>中大南方学院后门</td>\n",
       "      <td>239</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>99BARBECUE烤吧(中大店)</td>\n",
       "      <td>113.680449,23.629268</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCMIX1</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.7</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>[]</td>\n",
       "      <td>广州南方学院</td>\n",
       "      <td>261</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;四川菜(川菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050102</td>\n",
       "      <td>...</td>\n",
       "      <td>重庆湖边纸包鱼</td>\n",
       "      <td>113.680073,23.630511</td>\n",
       "      <td>13924024938</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFL7NUA2</td>\n",
       "      <td>[]</td>\n",
       "      <td>09:00-23:00</td>\n",
       "      <td>4.5</td>\n",
       "      <td>09:00-23:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇乌土村上围2队13号</td>\n",
       "      <td>268</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>壹休盖饭</td>\n",
       "      <td>113.679611,23.630517</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HRHG0RSP</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇笃行路20、22、24号中山大学南方学院商业中心二楼022号</td>\n",
       "      <td>268</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>爱鱼者酸菜鱼饭(中大店)</td>\n",
       "      <td>113.680193,23.630101</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1M7009J</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇笃行路</td>\n",
       "      <td>285</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>筷乐逸家</td>\n",
       "      <td>113.680147,23.630344</td>\n",
       "      <td>15811600514</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFL7CP5J</td>\n",
       "      <td>[]</td>\n",
       "      <td>09:00-21:00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>09:00-21:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>[]</td>\n",
       "      <td>中山大学南方学院</td>\n",
       "      <td>320</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>桃姐靓汤(中大南方店)</td>\n",
       "      <td>113.680188,23.630727</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HRO7LCM1</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉大道886号中山大学南方学院内</td>\n",
       "      <td>334</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>鱼家风范</td>\n",
       "      <td>113.680590,23.630575</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCL270</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方学院</td>\n",
       "      <td>359</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>长沙一绝</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCMY5T</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方学院</td>\n",
       "      <td>359</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>壹号饺子馆(中大店)</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCL9C0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉中大南方学院</td>\n",
       "      <td>359</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>淮南牛肉粉丝汤</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCKTON</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   parent                            address distance pname importance  \\\n",
       "0      []        温泉镇中山大学南方学院后门润泰超市首层01-02号商铺       18   广东省         []   \n",
       "1      []                  博学路6号(广州南方学院南门口旁)       19   广东省         []   \n",
       "2      []                        温泉镇中山大学南方学院      130   广东省         []   \n",
       "3      []                            温泉镇中大南方      146   广东省         []   \n",
       "4      []                        温泉镇中山大学南方学院      149   广东省         []   \n",
       "5      []                            温泉镇中大南方      150   广东省         []   \n",
       "6      []                        温泉镇中山大学南方学院      156   广东省         []   \n",
       "7      []                     温泉镇平岗村乌土平岗街29号      218   广东省         []   \n",
       "8      []                            乌土村中南公寓      231   广东省         []   \n",
       "9      []                         中南公寓首层022铺      231   广东省         []   \n",
       "10     []                           中大南方学院后门      239   广东省         []   \n",
       "11     []                             广州南方学院      261   广东省         []   \n",
       "12     []                      温泉镇乌土村上围2队13号      268   广东省         []   \n",
       "13     []  温泉镇笃行路20、22、24号中山大学南方学院商业中心二楼022号      268   广东省         []   \n",
       "14     []                             温泉镇笃行路      285   广东省         []   \n",
       "15     []                           中山大学南方学院      320   广东省         []   \n",
       "16     []                  温泉大道886号中山大学南方学院内      334   广东省         []   \n",
       "17     []                          温泉镇中大南方学院      359   广东省         []   \n",
       "18     []                          温泉镇中大南方学院      359   广东省         []   \n",
       "19     []                           温泉中大南方学院      359   广东省         []   \n",
       "\n",
       "   biz_type cityname                type  \\\n",
       "0     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "1     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "2     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "3     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "4     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "5     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "6     diner      广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "7     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "8     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "9     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "10    diner      广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "11    diner      广州市    餐饮服务;中餐厅;四川菜(川菜)   \n",
       "12    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "13    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "14    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "15    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "16    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "17    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "18    diner      广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "19    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "\n",
       "                                               photos typecode  ...  \\\n",
       "0                                                  []   050100  ...   \n",
       "1                                                  []   050100  ...   \n",
       "2                                                  []   050100  ...   \n",
       "3                                                  []   050100  ...   \n",
       "4                                                  []   050100  ...   \n",
       "5                                                  []   050100  ...   \n",
       "6                                                  []   050118  ...   \n",
       "7                                                  []   050100  ...   \n",
       "8                                                  []   050100  ...   \n",
       "9                                                  []   050100  ...   \n",
       "10                                                 []   050118  ...   \n",
       "11  [{'title': [], 'url': 'http://store.is.autonav...   050102  ...   \n",
       "12                                                 []   050100  ...   \n",
       "13                                                 []   050100  ...   \n",
       "14  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "15                                                 []   050100  ...   \n",
       "16                                                 []   050100  ...   \n",
       "17                                                 []   050100  ...   \n",
       "18                                                 []   050118  ...   \n",
       "19                                                 []   050100  ...   \n",
       "\n",
       "                 name              location          tel shopid          id  \\\n",
       "0          我家卖米粉(中大店)  113.678455,23.628393           []     []  B0HRO7MT5G   \n",
       "1              喜洋洋烧烤城  113.678474,23.628422           []     []  B0FFKT56Q8   \n",
       "2          港式住家饭(中大店)  113.679504,23.628108           []     []  B0H1M90UGD   \n",
       "3           找餐时间(轻食店)  113.679695,23.628204           []     []  B0H31YY48Q   \n",
       "4                1号粥店  113.679738,23.628307           []     []  B0HROCMB8D   \n",
       "5        巴老冒豆花冒菜(中大店)  113.679739,23.628221           []     []  B0HROCISXU   \n",
       "6                牛哥烧烤  113.679809,23.628326           []     []  B0HROCM3MH   \n",
       "7                桃缘瓦舍  113.680297,23.627788           []     []  B0IGC5BQCT   \n",
       "8               歡喜烤鱼饭  113.680349,23.627573           []     []  B0HROCIT9Q   \n",
       "9                过桥米线  113.680349,23.627573           []     []  B0H11HOB7J   \n",
       "10  99BARBECUE烤吧(中大店)  113.680449,23.629268           []     []  B0HROCMIX1   \n",
       "11            重庆湖边纸包鱼  113.680073,23.630511  13924024938     []  B0FFL7NUA2   \n",
       "12               壹休盖饭  113.679611,23.630517           []     []  B0HRHG0RSP   \n",
       "13       爱鱼者酸菜鱼饭(中大店)  113.680193,23.630101           []     []  B0H1M7009J   \n",
       "14               筷乐逸家  113.680147,23.630344  15811600514     []  B0FFL7CP5J   \n",
       "15        桃姐靓汤(中大南方店)  113.680188,23.630727           []     []  B0HRO7LCM1   \n",
       "16               鱼家风范  113.680590,23.630575           []     []  B0HROCL270   \n",
       "17               长沙一绝  113.676568,23.631259           []     []  B0HROCMY5T   \n",
       "18         壹号饺子馆(中大店)  113.676568,23.631259           []     []  B0HROCL9C0   \n",
       "19            淮南牛肉粉丝汤  113.676568,23.631259           []     []  B0HROCKTON   \n",
       "\n",
       "   biz_ext.cost biz_ext.opentime2 biz_ext.rating biz_ext.open_time  \\\n",
       "0            []                []             []                []   \n",
       "1            []                []             []                []   \n",
       "2            []                []             []                []   \n",
       "3            []                []             []                []   \n",
       "4            []                []             []                []   \n",
       "5            []                []             []                []   \n",
       "6            []                []             []                []   \n",
       "7            []                []            2.6                []   \n",
       "8            []                []             []                []   \n",
       "9            []                []             []                []   \n",
       "10           []                []            2.7                []   \n",
       "11           []       09:00-23:00            4.5       09:00-23:00   \n",
       "12           []                []             []                []   \n",
       "13           []                []             []                []   \n",
       "14           []       09:00-21:00            4.0       09:00-21:00   \n",
       "15           []                []             []                []   \n",
       "16           []                []             []                []   \n",
       "17           []                []             []                []   \n",
       "18           []                []             []                []   \n",
       "19           []                []             []                []   \n",
       "\n",
       "   biz_ext.meal_ordering  \n",
       "0                      0  \n",
       "1                      0  \n",
       "2                      0  \n",
       "3                      0  \n",
       "4                      0  \n",
       "5                      0  \n",
       "6                      0  \n",
       "7                      0  \n",
       "8                      0  \n",
       "9                      0  \n",
       "10                     0  \n",
       "11                     0  \n",
       "12                     0  \n",
       "13                     0  \n",
       "14                     0  \n",
       "15                     0  \n",
       "16                     0  \n",
       "17                     0  \n",
       "18                     0  \n",
       "19                     0  \n",
       "\n",
       "[20 rows x 24 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd.json_normalize(r.json()['pois'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "171da900",
   "metadata": {},
   "source": [
    "### 作业:\n",
    "> 1.尝试搜索POI2.0接口\n",
    "> 2.获取中餐厅、西餐厅、快餐厅（图片、内容等）"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "dd590db8",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 1.调用requests模块（google chrome浏览器）\n",
    "import requests\n",
    "\n",
    "# 2.请求方法：GET\n",
    "\n",
    "# 3.URL地址：https://restapi.amap.com/v5/place/text?parameters \n",
    "regeo_url = \"https://restapi.amap.com/v5/place/text?parameters\"\n",
    "\n",
    "# 4.准备参数，用于交换数据 payload\n",
    "payload ={\n",
    "    \"key\":\"b0121f143057c2f0c3607e48fe21bac9\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"types\":\"中餐厅|西餐厅|快餐厅\",\n",
    "    \"extensions\":\"all\",\n",
    "    \"poitype\":\"true\"\n",
    "}\n",
    "\n",
    "# 5.发起请求\n",
    "r = requests.get(url=regeo_url,params = payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "02536bbe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "e366145d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'pois': [{'name': '湖边纸包鱼',\n",
       "   'id': 'B0FFL7NUA2',\n",
       "   'location': '113.679861,23.630285',\n",
       "   'type': '餐饮服务;中餐厅;四川菜(川菜)',\n",
       "   'typecode': '050102',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '广州南方学院',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117'},\n",
       "  {'name': '壹休盖饭',\n",
       "   'id': 'B0HRHG0RSP',\n",
       "   'location': '113.679611,23.630517',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇乌土村上围2队13号',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117'},\n",
       "  {'name': 'Uni-hotel西餐',\n",
       "   'id': 'B0GR3OMDZ2',\n",
       "   'location': '113.679222,23.632671',\n",
       "   'type': '餐饮服务;外国餐厅;西餐厅(综合风味)',\n",
       "   'typecode': '050201',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉区广州南方学院',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117'},\n",
       "  {'name': '东记乡村美食',\n",
       "   'id': 'B0G3APADKJ',\n",
       "   'location': '113.679283,23.632572',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇广州南方学院后门润泰超市1层05号商铺',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117'},\n",
       "  {'name': '幸福楼酒店(温泉东路)',\n",
       "   'id': 'B00140FG8A',\n",
       "   'location': '113.654186,23.644836',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇温泉东路99号',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117'},\n",
       "  {'name': '佳乐堡',\n",
       "   'id': 'B0FFKT7WD8',\n",
       "   'location': '113.675576,23.620716',\n",
       "   'type': '餐饮服务;快餐厅;快餐厅',\n",
       "   'typecode': '050300',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇乌土村松浪队',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117'},\n",
       "  {'name': '柏如酒店',\n",
       "   'id': 'B00140H67T',\n",
       "   'location': '113.644626,23.638736',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉天湖路九号之一',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117'},\n",
       "  {'name': '天天酒家(温泉东路)',\n",
       "   'id': 'B00140LJS7',\n",
       "   'location': '113.657777,23.640442',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇牌坊东路45号',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117'},\n",
       "  {'name': '怡东楼',\n",
       "   'id': 'B0G0O5VQRS',\n",
       "   'location': '113.653053,23.653028',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅|住宿服务;宾馆酒店;宾馆酒店',\n",
       "   'typecode': '050100|100100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉东路113号',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117'},\n",
       "  {'name': '炳胜品味(海印总店)',\n",
       "   'id': 'B00140T9II',\n",
       "   'location': '113.286094,23.105431',\n",
       "   'type': '餐饮服务;中餐厅;广东菜(粤菜)',\n",
       "   'typecode': '050103',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '海珠区',\n",
       "   'address': '东晓路33号(近海印桥)',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440105'}],\n",
       " 'count': '10'}"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "665a838e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9497f98f",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
